Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 8514 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 931.3 KiB |
| Average record size in memory | 112.0 B |
Variable types
| NUM | 13 |
|---|---|
| BOOL | 1 |
Reproduction
| Analysis started | 2020-08-06 05:39:39.047847 |
|---|---|
| Analysis finished | 2020-08-06 05:40:18.402095 |
| Duration | 39.35 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
date is highly correlated with Unnamed: 0 and 2 other fields | High correlation |
Unnamed: 0 is highly correlated with date and 2 other fields | High correlation |
retweets_count is highly correlated with likes_count | High correlation |
likes_count is highly correlated with retweets_count | High correlation |
Cases_x is highly correlated with Unnamed: 0 and 2 other fields | High correlation |
Deaths_x is highly correlated with Unnamed: 0 and 2 other fields | High correlation |
replies_count is highly skewed (γ1 = 33.08903532) | Skewed |
Unnamed: 0 has unique values | Unique |
likes_count has 4190 (49.2%) zeros | Zeros |
replies_count has 5334 (62.6%) zeros | Zeros |
retweets_count has 5662 (66.5%) zeros | Zeros |
stopwords_count has 90 (1.1%) zeros | Zeros |
Sentiment has 1990 (23.4%) zeros | Zeros |
Target has 107 (1.3%) zeros | Zeros |
| Distinct count | 8514 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4256.5 |
|---|---|
| Minimum | 0 |
| Maximum | 8513 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 425.65 |
| Q1 | 2128.25 |
| median | 4256.5 |
| Q3 | 6384.75 |
| 95-th percentile | 8087.35 |
| Maximum | 8513 |
| Range | 8513 |
| Interquartile range (IQR) | 4256.5 |
Descriptive statistics
| Standard deviation | 2457.924429 |
|---|---|
| Coefficient of variation (CV) | 0.5774519979 |
| Kurtosis | -1.2 |
| Mean | 4256.5 |
| Median Absolute Deviation (MAD) | 2128.5 |
| Skewness | 0 |
| Sum | 36239841 |
| Variance | 6041392.5 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 1346 | 1 | < 0.1% | |
| 5416 | 1 | < 0.1% | |
| 7465 | 1 | < 0.1% | |
| 1322 | 1 | < 0.1% | |
| 3371 | 1 | < 0.1% | |
| 5424 | 1 | < 0.1% | |
| 7473 | 1 | < 0.1% | |
| 1330 | 1 | < 0.1% | |
| 3379 | 1 | < 0.1% | |
| Other values (8504) | 8504 | 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8513 | 1 | < 0.1% | |
| 8512 | 1 | < 0.1% | |
| 8511 | 1 | < 0.1% | |
| 8510 | 1 | < 0.1% | |
| 8509 | 1 | < 0.1% |
| Distinct count | 117 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20200423.67371388 |
|---|---|
| Minimum | 20200211 |
| Maximum | 20200610 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 20200211 |
|---|---|
| 5-th percentile | 20200312 |
| Q1 | 20200327 |
| median | 20200416 |
| Q3 | 20200508 |
| 95-th percentile | 20200602 |
| Maximum | 20200610 |
| Range | 399 |
| Interquartile range (IQR) | 181 |
Descriptive statistics
| Standard deviation | 88.72362317 |
|---|---|
| Coefficient of variation (CV) | 4.392166452e-06 |
| Kurtosis | -0.8602382792 |
| Mean | 20200423.67 |
| Median Absolute Deviation (MAD) | 90 |
| Skewness | 0.2982919838 |
| Sum | 1.719864072e+11 |
| Variance | 7871.881308 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 20200321 | 204 | 2.4% | |
| 20200417 | 144 | 1.7% | |
| 20200329 | 143 | 1.7% | |
| 20200322 | 136 | 1.6% | |
| 20200318 | 135 | 1.6% | |
| 20200415 | 134 | 1.6% | |
| 20200424 | 131 | 1.5% | |
| 20200312 | 128 | 1.5% | |
| 20200326 | 128 | 1.5% | |
| 20200323 | 128 | 1.5% | |
| Other values (107) | 7103 | 83.4% |
| Value | Count | Frequency (%) | |
| 20200211 | 1 | < 0.1% | |
| 20200213 | 3 | < 0.1% | |
| 20200215 | 1 | < 0.1% | |
| 20200216 | 2 | < 0.1% | |
| 20200217 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20200610 | 37 | 0.4% | |
| 20200609 | 49 | 0.6% | |
| 20200608 | 49 | 0.6% | |
| 20200607 | 41 | 0.5% | |
| 20200606 | 33 | 0.4% |
| Distinct count | 576 |
|---|---|
| Unique (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 767.1612638007987 |
|---|---|
| Minimum | 0 |
| Maximum | 160784 |
| Zeros | 4190 |
| Zeros (%) | 49.2% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 5 |
| 95-th percentile | 450 |
| Maximum | 160784 |
| Range | 160784 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 7949.310811 |
|---|---|
| Coefficient of variation (CV) | 10.36198148 |
| Kurtosis | 233.9179632 |
| Mean | 767.1612638 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 14.62936162 |
| Sum | 6531611 |
| Variance | 63191542.38 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 4190 | 49.2% | |
| 1 | 1215 | 14.3% | |
| 2 | 507 | 6.0% | |
| 3 | 290 | 3.4% | |
| 4 | 155 | 1.8% | |
| 5 | 112 | 1.3% | |
| 6 | 94 | 1.1% | |
| 7 | 75 | 0.9% | |
| 8 | 49 | 0.6% | |
| 9 | 44 | 0.5% | |
| Other values (566) | 1783 | 20.9% |
| Value | Count | Frequency (%) | |
| 0 | 4190 | 49.2% | |
| 1 | 1215 | 14.3% | |
| 2 | 507 | 6.0% | |
| 3 | 290 | 3.4% | |
| 4 | 155 | 1.8% |
| Value | Count | Frequency (%) | |
| 160784 | 3 | < 0.1% | |
| 147597 | 3 | < 0.1% | |
| 143100 | 4 | < 0.1% | |
| 142204 | 1 | < 0.1% | |
| 142203 | 1 | < 0.1% |
| Distinct count | 230 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 88.18722104768617 |
|---|---|
| Minimum | 0 |
| Maximum | 64215 |
| Zeros | 5334 |
| Zeros (%) | 62.6% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 56 |
| Maximum | 64215 |
| Range | 64215 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1526.553768 |
|---|---|
| Coefficient of variation (CV) | 17.31037388 |
| Kurtosis | 1265.134424 |
| Mean | 88.18722105 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 33.08903532 |
| Sum | 750826 |
| Variance | 2330366.407 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5334 | 62.6% | |
| 1 | 1344 | 15.8% | |
| 2 | 275 | 3.2% | |
| 3 | 135 | 1.6% | |
| 4 | 56 | 0.7% | |
| 5 | 45 | 0.5% | |
| 13 | 40 | 0.5% | |
| 16 | 34 | 0.4% | |
| 12 | 32 | 0.4% | |
| 26 | 31 | 0.4% | |
| Other values (220) | 1188 | 14.0% |
| Value | Count | Frequency (%) | |
| 0 | 5334 | 62.6% | |
| 1 | 1344 | 15.8% | |
| 2 | 275 | 3.2% | |
| 3 | 135 | 1.6% | |
| 4 | 56 | 0.7% |
| Value | Count | Frequency (%) | |
| 64215 | 3 | < 0.1% | |
| 43690 | 2 | < 0.1% | |
| 18417 | 2 | < 0.1% | |
| 15724 | 2 | < 0.1% | |
| 13879 | 3 | < 0.1% |
| Distinct count | 414 |
|---|---|
| Unique (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 179.75933756166313 |
|---|---|
| Minimum | 0 |
| Maximum | 34926 |
| Zeros | 5662 |
| Zeros (%) | 66.5% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 209 |
| Maximum | 34926 |
| Range | 34926 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1707.044549 |
|---|---|
| Coefficient of variation (CV) | 9.49627748 |
| Kurtosis | 229.6932844 |
| Mean | 179.7593376 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.40865622 |
| Sum | 1530471 |
| Variance | 2914001.093 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5662 | 66.5% | |
| 1 | 727 | 8.5% | |
| 2 | 272 | 3.2% | |
| 3 | 101 | 1.2% | |
| 4 | 71 | 0.8% | |
| 5 | 58 | 0.7% | |
| 6 | 44 | 0.5% | |
| 7 | 33 | 0.4% | |
| 8 | 32 | 0.4% | |
| 10 | 26 | 0.3% | |
| Other values (404) | 1488 | 17.5% |
| Value | Count | Frequency (%) | |
| 0 | 5662 | 66.5% | |
| 1 | 727 | 8.5% | |
| 2 | 272 | 3.2% | |
| 3 | 101 | 1.2% | |
| 4 | 71 | 0.8% |
| Value | Count | Frequency (%) | |
| 34926 | 4 | < 0.1% | |
| 31125 | 2 | < 0.1% | |
| 29868 | 3 | < 0.1% | |
| 28239 | 2 | < 0.1% | |
| 27320 | 3 | < 0.1% |
video
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 66.5 KiB |
| 0 | |
|---|---|
| 1 | 117 |
| Value | Count | Frequency (%) | |
| 0 | 8397 | 98.6% | |
| 1 | 117 | 1.4% |
| Distinct count | 107 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 750179.7269203664 |
|---|---|
| Minimum | 12 |
| Maximum | 2000702 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 1561 |
| Q1 | 102276 |
| median | 669272 |
| Q3 | 1288587 |
| 95-th percentile | 1837371 |
| Maximum | 2000702 |
| Range | 2000690 |
| Interquartile range (IQR) | 1186311 |
Descriptive statistics
| Standard deviation | 637881.8103 |
|---|---|
| Coefficient of variation (CV) | 0.8503053167 |
| Kurtosis | -1.227022928 |
| Mean | 750179.7269 |
| Median Absolute Deviation (MAD) | 585181 |
| Skewness | 0.3625637286 |
| Sum | 6387030195 |
| Variance | 4.068932039e+11 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 25825 | 204 | 2.4% | |
| 701996 | 144 | 1.7% | |
| 141205 | 143 | 1.7% | |
| 33761 | 136 | 1.6% | |
| 8917 | 135 | 1.6% | |
| 637974 | 134 | 1.6% | |
| 907908 | 131 | 1.5% | |
| 1561 | 128 | 1.5% | |
| 84091 | 128 | 1.5% | |
| 43850 | 128 | 1.5% | |
| Other values (97) | 7103 | 83.4% |
| Value | Count | Frequency (%) | |
| 12 | 1 | < 0.1% | |
| 13 | 9 | 0.1% | |
| 15 | 17 | 0.2% | |
| 16 | 7 | 0.1% | |
| 24 | 6 | 0.1% |
| Value | Count | Frequency (%) | |
| 2000702 | 37 | 0.4% | |
| 1979908 | 49 | 0.6% | |
| 1961781 | 49 | 0.6% | |
| 1944367 | 41 | 0.5% | |
| 1926636 | 33 | 0.4% |
| Distinct count | 103 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42540.72363166549 |
|---|---|
| Minimum | 0 |
| Maximum | 113631 |
| Zeros | 34 |
| Zeros (%) | 0.4% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 2300 |
| median | 35442 |
| Q3 | 78497 |
| 95-th percentile | 107169 |
| Maximum | 113631 |
| Range | 113631 |
| Interquartile range (IQR) | 76197 |
Descriptive statistics
| Standard deviation | 39020.81055 |
|---|---|
| Coefficient of variation (CV) | 0.9172577996 |
| Kurtosis | -1.348555261 |
| Mean | 42540.72363 |
| Median Absolute Deviation (MAD) | 34644 |
| Skewness | 0.3805612915 |
| Sum | 362191721 |
| Variance | 1522623656 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 456 | 204 | 2.4% | |
| 38056 | 144 | 1.7% | |
| 3561 | 143 | 1.7% | |
| 601 | 136 | 1.6% | |
| 188 | 135 | 1.6% | |
| 33329 | 134 | 1.6% | |
| 52867 | 131 | 1.5% | |
| 784 | 128 | 1.5% | |
| 1746 | 128 | 1.5% | |
| 43 | 128 | 1.5% | |
| Other values (93) | 7103 | 83.4% |
| Value | Count | Frequency (%) | |
| 0 | 34 | 0.4% | |
| 1 | 15 | 0.2% | |
| 6 | 23 | 0.3% | |
| 7 | 5 | 0.1% | |
| 11 | 13 | 0.2% |
| Value | Count | Frequency (%) | |
| 113631 | 37 | 0.4% | |
| 112714 | 49 | 0.6% | |
| 111774 | 49 | 0.6% | |
| 111269 | 41 | 0.5% | |
| 110818 | 33 | 0.4% |
word_count
Real number (ℝ≥0)
| Distinct count | 62 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.55837444209537 |
|---|---|
| Minimum | 4 |
| Maximum | 84 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 35 |
| median | 42 |
| Q3 | 47 |
| 95-th percentile | 52 |
| Maximum | 84 |
| Range | 80 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 10.50829349 |
|---|---|
| Coefficient of variation (CV) | 0.2656401745 |
| Kurtosis | 0.4329630092 |
| Mean | 39.55837444 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.9638101506 |
| Sum | 336800 |
| Variance | 110.4242321 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 42 | 494 | 5.8% | |
| 43 | 471 | 5.5% | |
| 45 | 460 | 5.4% | |
| 46 | 433 | 5.1% | |
| 47 | 404 | 4.7% | |
| 44 | 404 | 4.7% | |
| 48 | 394 | 4.6% | |
| 41 | 362 | 4.3% | |
| 49 | 326 | 3.8% | |
| 39 | 318 | 3.7% | |
| Other values (52) | 4448 | 52.2% |
| Value | Count | Frequency (%) | |
| 4 | 2 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 9 | 14 | 0.2% | |
| 10 | 12 | 0.1% |
| Value | Count | Frequency (%) | |
| 84 | 1 | < 0.1% | |
| 78 | 1 | < 0.1% | |
| 67 | 1 | < 0.1% | |
| 66 | 1 | < 0.1% | |
| 64 | 1 | < 0.1% |
avg_word_length
Real number (ℝ≥0)
| Distinct count | 2438 |
|---|---|
| Unique (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.543809359955163 |
|---|---|
| Minimum | 3.25757575757575 |
| Maximum | 31.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 3.257575758 |
|---|---|
| 5-th percentile | 4.186046512 |
| Q1 | 4.6875 |
| median | 5.179487179 |
| Q3 | 6.0625 |
| 95-th percentile | 7.925640244 |
| Maximum | 31.75 |
| Range | 28.49242424 |
| Interquartile range (IQR) | 1.375 |
Descriptive statistics
| Standard deviation | 1.336497416 |
|---|---|
| Coefficient of variation (CV) | 0.2410792525 |
| Kurtosis | 40.64776619 |
| Mean | 5.54380936 |
| Median Absolute Deviation (MAD) | 0.6189993746 |
| Skewness | 3.54408339 |
| Sum | 47199.99289 |
| Variance | 1.786225344 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 4.976190476 | 105 | 1.2% | |
| 5 | 78 | 0.9% | |
| 6 | 70 | 0.8% | |
| 4.75 | 45 | 0.5% | |
| 7 | 44 | 0.5% | |
| 4.5 | 43 | 0.5% | |
| 4.893617021 | 36 | 0.4% | |
| 4.6 | 36 | 0.4% | |
| 4.490196078 | 34 | 0.4% | |
| 4.770833333 | 32 | 0.4% | |
| Other values (2428) | 7991 | 93.9% |
| Value | Count | Frequency (%) | |
| 3.257575758 | 1 | < 0.1% | |
| 3.419354839 | 1 | < 0.1% | |
| 3.527272727 | 1 | < 0.1% | |
| 3.542372881 | 2 | < 0.1% | |
| 3.55 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 31.75 | 2 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 16.30769231 | 1 | < 0.1% | |
| 15.77777778 | 2 | < 0.1% | |
| 14.62962963 | 1 | < 0.1% |
| Distinct count | 35 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.521963824289406 |
|---|---|
| Minimum | 0 |
| Maximum | 34 |
| Zeros | 90 |
| Zeros (%) | 1.1% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 15 |
| Q3 | 19 |
| 95-th percentile | 23 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.938369332 |
|---|---|
| Coefficient of variation (CV) | 0.4089232974 |
| Kurtosis | -0.2697309713 |
| Mean | 14.52196382 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.3005748253 |
| Sum | 123640 |
| Variance | 35.26423033 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 13 | 694 | 8.2% | |
| 17 | 589 | 6.9% | |
| 15 | 588 | 6.9% | |
| 16 | 568 | 6.7% | |
| 14 | 535 | 6.3% | |
| 18 | 512 | 6.0% | |
| 19 | 504 | 5.9% | |
| 20 | 482 | 5.7% | |
| 12 | 443 | 5.2% | |
| 11 | 385 | 4.5% | |
| Other values (25) | 3214 | 37.7% |
| Value | Count | Frequency (%) | |
| 0 | 90 | 1.1% | |
| 1 | 49 | 0.6% | |
| 2 | 119 | 1.4% | |
| 3 | 191 | 2.2% | |
| 4 | 201 | 2.4% |
| Value | Count | Frequency (%) | |
| 34 | 1 | < 0.1% | |
| 33 | 2 | < 0.1% | |
| 32 | 2 | < 0.1% | |
| 31 | 3 | < 0.1% | |
| 30 | 7 | 0.1% |
char_count
Real number (ℝ≥0)
| Distinct count | 376 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 252.33192389006342 |
|---|---|
| Minimum | 51 |
| Maximum | 585 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | 51 |
|---|---|
| 5-th percentile | 115 |
| Q1 | 226 |
| median | 268 |
| Q3 | 280 |
| 95-th percentile | 342 |
| Maximum | 585 |
| Range | 534 |
| Interquartile range (IQR) | 54 |
Descriptive statistics
| Standard deviation | 64.70749952 |
|---|---|
| Coefficient of variation (CV) | 0.2564380223 |
| Kurtosis | 0.9104624038 |
| Mean | 252.3319239 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | -0.5212346096 |
| Sum | 2148354 |
| Variance | 4187.060494 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 280 | 401 | 4.7% | |
| 279 | 381 | 4.5% | |
| 278 | 284 | 3.3% | |
| 277 | 242 | 2.8% | |
| 275 | 202 | 2.4% | |
| 276 | 200 | 2.3% | |
| 251 | 164 | 1.9% | |
| 274 | 138 | 1.6% | |
| 272 | 130 | 1.5% | |
| 271 | 120 | 1.4% | |
| Other values (366) | 6252 | 73.4% |
| Value | Count | Frequency (%) | |
| 51 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% | |
| 66 | 2 | < 0.1% | |
| 68 | 3 | < 0.1% | |
| 72 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 585 | 1 | < 0.1% | |
| 584 | 1 | < 0.1% | |
| 578 | 1 | < 0.1% | |
| 519 | 1 | < 0.1% | |
| 511 | 1 | < 0.1% |
| Distinct count | 1233 |
|---|---|
| Unique (%) | 14.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0319829873673658 |
|---|---|
| Minimum | -1.0 |
| Maximum | 1.0 |
| Zeros | 1990 |
| Zeros (%) | 23.4% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -0.4 |
| Q1 | -0.07222222222 |
| median | 0 |
| Q3 | 0.1666666667 |
| 95-th percentile | 0.45 |
| Maximum | 1 |
| Range | 2 |
| Interquartile range (IQR) | 0.2388888889 |
Descriptive statistics
| Standard deviation | 0.2572901493 |
|---|---|
| Coefficient of variation (CV) | 8.044594031 |
| Kurtosis | 1.954804969 |
| Mean | 0.03198298737 |
| Median Absolute Deviation (MAD) | 0.1258225108 |
| Skewness | -0.2200270062 |
| Sum | 272.3031544 |
| Variance | 0.06619822091 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 1990 | 23.4% | |
| 0.4 | 275 | 3.2% | |
| 0.2 | 194 | 2.3% | |
| 0.1 | 175 | 2.1% | |
| 0.25 | 172 | 2.0% | |
| 0.5 | 156 | 1.8% | |
| -0.2 | 141 | 1.7% | |
| -0.1 | 131 | 1.5% | |
| 0.1666666667 | 122 | 1.4% | |
| -0.3 | 116 | 1.4% | |
| Other values (1223) | 5042 | 59.2% |
| Value | Count | Frequency (%) | |
| -1 | 33 | 0.4% | |
| -0.9 | 8 | 0.1% | |
| -0.85 | 1 | < 0.1% | |
| -0.8 | 31 | 0.4% | |
| -0.8 | 11 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 19 | 0.2% | |
| 0.9 | 2 | < 0.1% | |
| 0.85 | 4 | < 0.1% | |
| 0.8 | 32 | 0.4% | |
| 0.8 | 4 | < 0.1% |
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.49318769086211 |
|---|---|
| Minimum | -4.0 |
| Maximum | 14.0 |
| Zeros | 107 |
| Zeros (%) | 1.3% |
| Memory size | 66.5 KiB |
Quantile statistics
| Minimum | -4 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 14 |
| Range | 18 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.72697703 |
|---|---|
| Coefficient of variation (CV) | 0.4199750815 |
| Kurtosis | 0.1880294348 |
| Mean | 6.493187691 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.5614240962 |
| Sum | 55283 |
| Variance | 7.436403722 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 6 | 2322 | 27.3% | |
| 4 | 1700 | 20.0% | |
| 10 | 1193 | 14.0% | |
| 5 | 700 | 8.2% | |
| 9 | 656 | 7.7% | |
| 7 | 572 | 6.7% | |
| 3 | 481 | 5.6% | |
| 14 | 251 | 2.9% | |
| 8 | 217 | 2.5% | |
| 11 | 212 | 2.5% | |
| Other values (3) | 210 | 2.5% |
| Value | Count | Frequency (%) | |
| -4 | 3 | < 0.1% | |
| 0 | 107 | 1.3% | |
| 2 | 100 | 1.2% | |
| 3 | 481 | 5.6% | |
| 4 | 1700 | 20.0% |
| Value | Count | Frequency (%) | |
| 14 | 251 | 2.9% | |
| 11 | 212 | 2.5% | |
| 10 | 1193 | 14.0% | |
| 9 | 656 | 7.7% | |
| 8 | 217 | 2.5% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Unnamed: 0 | date | likes_count | replies_count | retweets_count | video | Cases_x | Deaths_x | word_count | avg_word_length | stopwords_count | char_count | Sentiment | Target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 20200211 | 4374 | 464 | 2189 | 0 | 12 | 0 | 41 | 5.536585 | 16 | 269 | 0.000000 | 7.0 |
| 1 | 1 | 20200213 | 0 | 0 | 0 | 0 | 13 | 0 | 38 | 7.894737 | 15 | 338 | 0.375000 | 7.0 |
| 2 | 2 | 20200213 | 0 | 0 | 0 | 0 | 13 | 0 | 37 | 8.500000 | 15 | 361 | 0.375000 | 7.0 |
| 3 | 3 | 20200213 | 0 | 0 | 0 | 0 | 13 | 0 | 39 | 8.550000 | 15 | 382 | 0.048611 | 7.0 |
| 4 | 4 | 20200215 | 0 | 0 | 0 | 0 | 13 | 0 | 34 | 8.457143 | 10 | 330 | 0.216667 | 6.0 |
| 5 | 5 | 20200216 | 5 | 0 | 0 | 0 | 13 | 0 | 41 | 5.950000 | 18 | 278 | 0.000000 | 7.0 |
| 6 | 6 | 20200216 | 5 | 0 | 0 | 0 | 13 | 0 | 41 | 5.950000 | 18 | 278 | 0.000000 | 7.0 |
| 7 | 7 | 20200217 | 2 | 1 | 0 | 0 | 13 | 0 | 39 | 7.128205 | 11 | 317 | 0.178788 | 7.0 |
| 8 | 8 | 20200219 | 88 | 5 | 47 | 0 | 13 | 0 | 13 | 6.083333 | 3 | 86 | 0.000000 | -4.0 |
| 9 | 9 | 20200219 | 89 | 5 | 47 | 0 | 13 | 0 | 13 | 6.083333 | 3 | 86 | 0.000000 | -4.0 |
Last rows
| Unnamed: 0 | date | likes_count | replies_count | retweets_count | video | Cases_x | Deaths_x | word_count | avg_word_length | stopwords_count | char_count | Sentiment | Target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8504 | 8504 | 20200610 | 1 | 0 | 0 | 0 | 2000702 | 113631 | 32 | 3.718750 | 15 | 150 | 0.000000 | 8.0 |
| 8505 | 8505 | 20200610 | 0 | 1 | 0 | 0 | 2000702 | 113631 | 35 | 5.485714 | 14 | 226 | 0.100000 | 8.0 |
| 8506 | 8506 | 20200610 | 1 | 0 | 0 | 0 | 2000702 | 113631 | 56 | 4.017857 | 22 | 280 | -0.160317 | 8.0 |
| 8507 | 8507 | 20200610 | 0 | 0 | 0 | 0 | 2000702 | 113631 | 57 | 4.188679 | 24 | 278 | -0.070089 | 8.0 |
| 8508 | 8508 | 20200610 | 1 | 0 | 0 | 0 | 2000702 | 113631 | 40 | 8.536585 | 10 | 392 | 0.000000 | 8.0 |
| 8509 | 8509 | 20200610 | 0 | 0 | 0 | 0 | 2000702 | 113631 | 51 | 3.882353 | 21 | 248 | 0.433333 | 8.0 |
| 8510 | 8510 | 20200610 | 0 | 1 | 0 | 0 | 2000702 | 113631 | 55 | 4.129630 | 22 | 277 | -0.354762 | 8.0 |
| 8511 | 8511 | 20200610 | 0 | 0 | 0 | 0 | 2000702 | 113631 | 50 | 3.979167 | 17 | 240 | -0.266667 | 8.0 |
| 8512 | 8512 | 20200610 | 159 | 28 | 40 | 0 | 2000702 | 113631 | 36 | 5.722222 | 13 | 242 | 0.250000 | 8.0 |
| 8513 | 8513 | 20200610 | 0 | 0 | 0 | 0 | 2000702 | 113631 | 47 | 4.782609 | 15 | 266 | 0.050000 | 8.0 |